www.gusucode.com > 帝国网站管理系统(帝国CMS) 6 > 帝国网站管理系统(帝国CMS) 6.5繁体UTF-8/upload/e/wap/list.php
<?php require("../class/connect.php"); require("../class/db_sql.php"); require("../class/q_functions.php"); require("../data/dbcache/class.php"); $link=db_connect(); $empire=new mysqlquery(); define('WapPage','list'); require("wapfun.php"); //欄目ID $classid=(int)$_GET['classid']; if(!$classid||!$class_r[$classid]['tbname']) { DoWapShowMsg('您來自的鏈接不存在','index.php?style=$wapstyle'); } $pagetitle=$class_r[$classid]['classname']; $bclassid=(int)$_GET['bclassid']; $search=''; $add=''; if($class_r[$classid]['islast']) { $add.=" and classid='$classid'"; } else { $where=ReturnClass($class_r[$classid][sonclass]); $add.=" and (".$where.")"; } $modid=$class_r[$classid][modid]; //優化 $yhid=$class_r[$classid][yhid]; $yhvar='qlist'; $yhadd=''; if($yhid) { $yhadd=ReturnYhSql($yhid,$yhvar); } $search.="&style=$wapstyle&classid=$classid&bclassid=$bclassid"; $page=intval($_GET['page']); $line=$pr['waplistnum'];//每頁顯示記錄數 $offset=$page*$line; $query="select ".ReturnSqlListF($modid)." from {$dbtbpre}ecms_".$class_r[$classid]['tbname']." where ".$yhadd."checked=1".$add; $totalnum=intval($_GET['totalnum']); if(empty($totalnum)) { $totalquery="select count(*) as total from {$dbtbpre}ecms_".$class_r[$classid]['tbname']." where ".$yhadd."checked=1".$add; $num=$empire->gettotal($totalquery);//取得總條數 } else { $num=$totalnum; } $search.="&totalnum=$num"; //排序 if(empty($class_r[$classid][reorder])) { $addorder="newstime desc"; } else { $addorder=$class_r[$classid][reorder]; } $query.=" order by ".ReturnSetTopSql('list').$addorder." limit $offset,$line"; $sql=$empire->query($query); $returnpage=DoWapListPage($num,$line,$page,$search); //系統模型 $ret_r=ReturnAddF($modid,2); require('template/'.$usewapstyle.'/list.temp.php'); db_close(); $empire=null; ?>